Overview
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 6999 |
| Missing cells | 1006 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 493 |
| Duplicate rows (%) | 7.0% |
| Total size in memory | 287.8 KiB |
| Average record size in memory | 42.1 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 8 |
| Categorical | 4 |
| Dataset has 493 (7.0%) duplicate rows | Duplicates |
engine is highly overall correlated with max_power and 3 other fields | High correlation |
km_driven is highly overall correlated with year | High correlation |
max_power is highly overall correlated with engine and 3 other fields | High correlation |
seats is highly overall correlated with engine | High correlation |
selling_price is highly overall correlated with engine and 4 other fields | High correlation |
torque is highly overall correlated with engine and 2 other fields | High correlation |
transmission is highly overall correlated with max_power and 1 other fields | High correlation |
year is highly overall correlated with km_driven and 1 other fields | High correlation |
seller_type is highly imbalanced (51.8%) | Imbalance |
mileage has 202 (2.9%) missing values | Missing |
engine has 202 (2.9%) missing values | Missing |
max_power has 197 (2.8%) missing values | Missing |
torque has 203 (2.9%) missing values | Missing |
seats has 202 (2.9%) missing values | Missing |
Reproduction
| Analysis started | 2026-01-01 16:55:16.466942 |
|---|---|
| Analysis finished | 2026-01-01 16:55:19.493761 |
| Duration | 3.03 seconds |
| Software version | ydata-profiling vv4.18.0 |
| Download configuration | config.json |
Variables
name
Text
| Distinct | 1924 |
|---|---|
| Distinct (%) | 27.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 42 |
| Mean length | 25.227747 |
| Min length | 11 |
Unique
| Unique | 804 ? |
|---|---|
| Unique (%) | 11.5% |
Sample
| 1st row | Maruti Swift Dzire VDI |
|---|---|
| 2nd row | Skoda Rapid 1.5 TDI Ambition |
| 3rd row | Hyundai i20 Sportz Diesel |
| 4th row | Maruti Swift VXI BSIII |
| 5th row | Hyundai Xcent 1.2 VTVT E Plus |
| Value | Count | Frequency (%) |
| maruti | 2126 | 6.4% |
| hyundai | 1197 | 3.6% |
| swift | 689 | 2.1% |
| mahindra | 666 | 2.0% |
| bsiv | 622 | 1.9% |
| tata | 611 | 1.8% |
| diesel | 583 | 1.8% |
| 1.2 | 505 | 1.5% |
| vxi | 485 | 1.5% |
| plus | 459 | 1.4% |
| Other values (828) | 25224 |
Most occurring characters
| Value | Count | Frequency (%) |
| 26169 | 14.8% | |
| a | 12741 | 7.2% |
| i | 11534 | 6.5% |
| t | 8812 | 5.0% |
| r | 7759 | 4.4% |
| o | 7165 | 4.1% |
| n | 6573 | 3.7% |
| e | 6564 | 3.7% |
| u | 5091 | 2.9% |
| S | 4755 | 2.7% |
| Other values (58) | 79406 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 176569 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 26169 | 14.8% | |
| a | 12741 | 7.2% |
| i | 11534 | 6.5% |
| t | 8812 | 5.0% |
| r | 7759 | 4.4% |
| o | 7165 | 4.1% |
| n | 6573 | 3.7% |
| e | 6564 | 3.7% |
| u | 5091 | 2.9% |
| S | 4755 | 2.7% |
| Other values (58) | 79406 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 176569 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 26169 | 14.8% | |
| a | 12741 | 7.2% |
| i | 11534 | 6.5% |
| t | 8812 | 5.0% |
| r | 7759 | 4.4% |
| o | 7165 | 4.1% |
| n | 6573 | 3.7% |
| e | 6564 | 3.7% |
| u | 5091 | 2.9% |
| S | 4755 | 2.7% |
| Other values (58) | 79406 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 176569 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 26169 | 14.8% | |
| a | 12741 | 7.2% |
| i | 11534 | 6.5% |
| t | 8812 | 5.0% |
| r | 7759 | 4.4% |
| o | 7165 | 4.1% |
| n | 6573 | 3.7% |
| e | 6564 | 3.7% |
| u | 5091 | 2.9% |
| S | 4755 | 2.7% |
| Other values (58) | 79406 |
year
Real number (ℝ)
High correlation
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.8184 |
| Minimum | 1983 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.8 KiB |
Quantile statistics
| Minimum | 1983 |
|---|---|
| 5-th percentile | 2006 |
| Q1 | 2011 |
| median | 2015 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 37 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.0530948 |
|---|---|
| Coefficient of variation (CV) | 0.0020126417 |
| Kurtosis | 1.7672148 |
| Mean | 2013.8184 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.0773023 |
| Sum | 14094715 |
| Variance | 16.427578 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2017 | 870 | |
| 2016 | 736 | |
| 2018 | 704 | |
| 2015 | 662 | |
| 2013 | 581 | |
| 2012 | 563 | |
| 2014 | 532 | |
| 2019 | 511 | |
| 2011 | 499 | |
| 2010 | 336 | 4.8% |
| Other values (19) | 1005 |
| Value | Count | Frequency (%) |
| 1983 | 1 | < 0.1% |
| 1991 | 1 | < 0.1% |
| 1994 | 3 | < 0.1% |
| 1995 | 1 | < 0.1% |
| 1996 | 3 | < 0.1% |
| 1997 | 10 | |
| 1998 | 9 | |
| 1999 | 13 | |
| 2000 | 21 | |
| 2001 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 2020 | 69 | 1.0% |
| 2019 | 511 | |
| 2018 | 704 | |
| 2017 | 870 | |
| 2016 | 736 | |
| 2015 | 662 | |
| 2014 | 532 | |
| 2013 | 581 | |
| 2012 | 563 | |
| 2011 | 499 |
selling_price
Real number (ℝ)
High correlation
| Distinct | 637 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 639515.2 |
| Minimum | 29999 |
|---|---|
| Maximum | 10000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 29999 |
|---|---|
| 5-th percentile | 110000 |
| Q1 | 254999 |
| median | 450000 |
| Q3 | 675000 |
| 95-th percentile | 1925000 |
| Maximum | 10000000 |
| Range | 9970001 |
| Interquartile range (IQR) | 420001 |
Descriptive statistics
| Standard deviation | 808941.91 |
|---|---|
| Coefficient of variation (CV) | 1.2649299 |
| Kurtosis | 21.308644 |
| Mean | 639515.2 |
| Median Absolute Deviation (MAD) | 200000 |
| Skewness | 4.2107557 |
| Sum | 4.4759669 × 109 |
| Variance | 6.5438702 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300000 | 196 | 2.8% |
| 600000 | 181 | 2.6% |
| 450000 | 178 | 2.5% |
| 350000 | 178 | 2.5% |
| 550000 | 175 | 2.5% |
| 650000 | 161 | 2.3% |
| 400000 | 153 | 2.2% |
| 250000 | 153 | 2.2% |
| 500000 | 152 | 2.2% |
| 200000 | 138 | 2.0% |
| Other values (627) | 5334 |
| Value | Count | Frequency (%) |
| 29999 | 1 | < 0.1% |
| 30000 | 2 | < 0.1% |
| 31504 | 1 | < 0.1% |
| 35000 | 3 | < 0.1% |
| 39000 | 1 | < 0.1% |
| 40000 | 12 | |
| 42000 | 2 | < 0.1% |
| 45000 | 16 | |
| 45957 | 2 | < 0.1% |
| 50000 | 15 |
| Value | Count | Frequency (%) |
| 10000000 | 1 | < 0.1% |
| 7200000 | 1 | < 0.1% |
| 6523000 | 1 | < 0.1% |
| 6223000 | 1 | < 0.1% |
| 6000000 | 4 | 0.1% |
| 5923000 | 1 | < 0.1% |
| 5850000 | 1 | < 0.1% |
| 5830000 | 2 | < 0.1% |
| 5800000 | 2 | < 0.1% |
| 5500000 | 27 |
km_driven
Real number (ℝ)
High correlation
| Distinct | 827 |
|---|---|
| Distinct (%) | 11.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69584.616 |
| Minimum | 1 |
|---|---|
| Maximum | 2360457 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9000 |
| Q1 | 35000 |
| median | 60000 |
| Q3 | 97000 |
| 95-th percentile | 150000 |
| Maximum | 2360457 |
| Range | 2360456 |
| Interquartile range (IQR) | 62000 |
Descriptive statistics
| Standard deviation | 57724.002 |
|---|---|
| Coefficient of variation (CV) | 0.82955121 |
| Kurtosis | 410.79799 |
| Mean | 69584.616 |
| Median Absolute Deviation (MAD) | 30000 |
| Skewness | 12.069152 |
| Sum | 4.8702272 × 108 |
| Variance | 3.3320604 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 120000 | 464 | 6.6% |
| 70000 | 389 | 5.6% |
| 80000 | 387 | 5.5% |
| 60000 | 367 | 5.2% |
| 50000 | 343 | 4.9% |
| 100000 | 306 | 4.4% |
| 90000 | 291 | 4.2% |
| 110000 | 264 | 3.8% |
| 40000 | 260 | 3.7% |
| 30000 | 215 | 3.1% |
| Other values (817) | 3713 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 1000 | 6 | 0.1% |
| 1300 | 1 | < 0.1% |
| 1303 | 4 | 0.1% |
| 1500 | 3 | < 0.1% |
| 1600 | 1 | < 0.1% |
| 1620 | 1 | < 0.1% |
| 2000 | 28 | |
| 2118 | 1 | < 0.1% |
| 2136 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2360457 | 1 | |
| 1500000 | 1 | |
| 577414 | 1 | |
| 500000 | 2 | |
| 475000 | 1 | |
| 440000 | 1 | |
| 426000 | 1 | |
| 380000 | 1 | |
| 376412 | 1 | |
| 370000 | 1 |
fuel
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.2 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 52 |
| LPG | 34 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.9631376 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Diesel |
|---|---|
| 2nd row | Diesel |
| 3rd row | Diesel |
| 4th row | Petrol |
| 5th row | Petrol |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3793 | |
| Petrol | 3120 | |
| CNG | 52 | 0.7% |
| LPG | 34 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3793 | |
| petrol | 3120 | |
| cng | 52 | 0.7% |
| lpg | 34 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10706 | |
| l | 6913 | |
| D | 3793 | 9.1% |
| i | 3793 | 9.1% |
| s | 3793 | 9.1% |
| P | 3154 | 7.6% |
| t | 3120 | 7.5% |
| r | 3120 | 7.5% |
| o | 3120 | 7.5% |
| G | 86 | 0.2% |
| Other values (3) | 138 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41736 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10706 | |
| l | 6913 | |
| D | 3793 | 9.1% |
| i | 3793 | 9.1% |
| s | 3793 | 9.1% |
| P | 3154 | 7.6% |
| t | 3120 | 7.5% |
| r | 3120 | 7.5% |
| o | 3120 | 7.5% |
| G | 86 | 0.2% |
| Other values (3) | 138 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41736 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10706 | |
| l | 6913 | |
| D | 3793 | 9.1% |
| i | 3793 | 9.1% |
| s | 3793 | 9.1% |
| P | 3154 | 7.6% |
| t | 3120 | 7.5% |
| r | 3120 | 7.5% |
| o | 3120 | 7.5% |
| G | 86 | 0.2% |
| Other values (3) | 138 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41736 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10706 | |
| l | 6913 | |
| D | 3793 | 9.1% |
| i | 3793 | 9.1% |
| s | 3793 | 9.1% |
| P | 3154 | 7.6% |
| t | 3120 | 7.5% |
| r | 3120 | 7.5% |
| o | 3120 | 7.5% |
| G | 86 | 0.2% |
| Other values (3) | 138 | 0.3% |
seller_type
Categorical
Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.1 KiB |
| Individual | |
|---|---|
| Dealer | |
| Trustmark Dealer | 206 |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.6239463 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Individual |
|---|---|
| 2nd row | Individual |
| 3rd row | Individual |
| 4th row | Individual |
| 5th row | Individual |
Common Values
| Value | Count | Frequency (%) |
| Individual | 5826 | |
| Dealer | 967 | 13.8% |
| Trustmark Dealer | 206 | 2.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| individual | 5826 | |
| dealer | 1173 | 16.3% |
| trustmark | 206 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 11652 | |
| i | 11652 | |
| a | 7205 | |
| l | 6999 | |
| u | 6032 | |
| I | 5826 | |
| v | 5826 | |
| n | 5826 | |
| e | 2346 | 3.5% |
| r | 1585 | 2.4% |
| Other values (7) | 2409 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 67358 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| d | 11652 | |
| i | 11652 | |
| a | 7205 | |
| l | 6999 | |
| u | 6032 | |
| I | 5826 | |
| v | 5826 | |
| n | 5826 | |
| e | 2346 | 3.5% |
| r | 1585 | 2.4% |
| Other values (7) | 2409 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 67358 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| d | 11652 | |
| i | 11652 | |
| a | 7205 | |
| l | 6999 | |
| u | 6032 | |
| I | 5826 | |
| v | 5826 | |
| n | 5826 | |
| e | 2346 | 3.5% |
| r | 1585 | 2.4% |
| Other values (7) | 2409 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 67358 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| d | 11652 | |
| i | 11652 | |
| a | 7205 | |
| l | 6999 | |
| u | 6032 | |
| I | 5826 | |
| v | 5826 | |
| n | 5826 | |
| e | 2346 | 3.5% |
| r | 1585 | 2.4% |
| Other values (7) | 2409 | 3.6% |
transmission
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.1 KiB |
| Manual | |
|---|---|
| Automatic |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.3874839 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Manual |
Common Values
| Value | Count | Frequency (%) |
| Manual | 6095 | |
| Automatic | 904 | 12.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 6095 | |
| automatic | 904 | 12.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13094 | |
| u | 6999 | |
| M | 6095 | |
| n | 6095 | |
| l | 6095 | |
| t | 1808 | 4.0% |
| A | 904 | 2.0% |
| o | 904 | 2.0% |
| m | 904 | 2.0% |
| i | 904 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 44706 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 13094 | |
| u | 6999 | |
| M | 6095 | |
| n | 6095 | |
| l | 6095 | |
| t | 1808 | 4.0% |
| A | 904 | 2.0% |
| o | 904 | 2.0% |
| m | 904 | 2.0% |
| i | 904 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 44706 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 13094 | |
| u | 6999 | |
| M | 6095 | |
| n | 6095 | |
| l | 6095 | |
| t | 1808 | 4.0% |
| A | 904 | 2.0% |
| o | 904 | 2.0% |
| m | 904 | 2.0% |
| i | 904 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 44706 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 13094 | |
| u | 6999 | |
| M | 6095 | |
| n | 6095 | |
| l | 6095 | |
| t | 1808 | 4.0% |
| A | 904 | 2.0% |
| o | 904 | 2.0% |
| m | 904 | 2.0% |
| i | 904 | 2.0% |
owner
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.2 KiB |
| First Owner | |
|---|---|
| Second Owner | |
| Third Owner | |
| Fourth & Above Owner | 144 |
| Test Drive Car | 4 |
Length
| Max length | 20 |
|---|---|
| Median length | 11 |
| Mean length | 11.442778 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First Owner |
|---|---|
| 2nd row | Second Owner |
| 3rd row | First Owner |
| 4th row | First Owner |
| 5th row | First Owner |
Common Values
| Value | Count | Frequency (%) |
| First Owner | 4587 | |
| Second Owner | 1791 | 25.6% |
| Third Owner | 473 | 6.8% |
| Fourth & Above Owner | 144 | 2.1% |
| Test Drive Car | 4 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| owner | 6995 | |
| first | 4587 | |
| second | 1791 | 12.5% |
| third | 473 | 3.3% |
| fourth | 144 | 1.0% |
| 144 | 1.0% | |
| above | 144 | 1.0% |
| test | 4 | < 0.1% |
| drive | 4 | < 0.1% |
| car | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 12207 | |
| e | 8938 | |
| n | 8786 | |
| 7291 | ||
| O | 6995 | |
| w | 6995 | |
| i | 5064 | |
| t | 4735 | 5.9% |
| F | 4731 | 5.9% |
| s | 4591 | 5.7% |
| Other values (14) | 9755 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80088 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 12207 | |
| e | 8938 | |
| n | 8786 | |
| 7291 | ||
| O | 6995 | |
| w | 6995 | |
| i | 5064 | |
| t | 4735 | 5.9% |
| F | 4731 | 5.9% |
| s | 4591 | 5.7% |
| Other values (14) | 9755 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80088 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 12207 | |
| e | 8938 | |
| n | 8786 | |
| 7291 | ||
| O | 6995 | |
| w | 6995 | |
| i | 5064 | |
| t | 4735 | 5.9% |
| F | 4731 | 5.9% |
| s | 4591 | 5.7% |
| Other values (14) | 9755 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80088 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 12207 | |
| e | 8938 | |
| n | 8786 | |
| 7291 | ||
| O | 6995 | |
| w | 6995 | |
| i | 5064 | |
| t | 4735 | 5.9% |
| F | 4731 | 5.9% |
| s | 4591 | 5.7% |
| Other values (14) | 9755 |
mileage
Real number (ℝ)
Missing
| Distinct | 375 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 202 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.426604 |
| Minimum | 0 |
|---|---|
| Maximum | 42 |
| Zeros | 16 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12.99 |
| Q1 | 16.799999 |
| median | 19.299999 |
| Q3 | 22.32 |
| 95-th percentile | 25.83 |
| Maximum | 42 |
| Range | 42 |
| Interquartile range (IQR) | 5.5200005 |
Descriptive statistics
| Standard deviation | 4.045692 |
|---|---|
| Coefficient of variation (CV) | 0.20825523 |
| Kurtosis | 0.67758536 |
| Mean | 19.426604 |
| Median Absolute Deviation (MAD) | 2.7000008 |
| Skewness | -0.15136978 |
| Sum | 132042.63 |
| Variance | 16.367624 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.89999962 | 197 | 2.8% |
| 19.70000076 | 150 | 2.1% |
| 18.60000038 | 139 | 2.0% |
| 21.10000038 | 131 | 1.9% |
| 17 | 116 | 1.7% |
| 15.96000004 | 105 | 1.5% |
| 17.79999924 | 101 | 1.4% |
| 22 | 99 | 1.4% |
| 12.98999977 | 95 | 1.4% |
| 16.10000038 | 90 | 1.3% |
| Other values (365) | 5574 | |
| (Missing) | 202 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 16 | |
| 9 | 4 | 0.1% |
| 9.5 | 5 | 0.1% |
| 10 | 2 | < 0.1% |
| 10.10000038 | 2 | < 0.1% |
| 10.5 | 14 | |
| 10.71000004 | 1 | < 0.1% |
| 10.75 | 2 | < 0.1% |
| 10.80000019 | 1 | < 0.1% |
| 10.89999962 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 42 | 1 | < 0.1% |
| 33.43999863 | 3 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32.52000046 | 1 | < 0.1% |
| 30.45999908 | 2 | < 0.1% |
| 28.39999962 | 80 | |
| 28.09000015 | 36 | |
| 27.62000084 | 5 | 0.1% |
| 27.39999962 | 6 | 0.1% |
| 27.38999939 | 49 |
engine
Real number (ℝ)
High correlation Missing
| Distinct | 120 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 202 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1458.3272 |
| Minimum | 624 |
|---|---|
| Maximum | 3604 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 624 |
|---|---|
| 5-th percentile | 796 |
| Q1 | 1197 |
| median | 1248 |
| Q3 | 1582 |
| 95-th percentile | 2499 |
| Maximum | 3604 |
| Range | 2980 |
| Interquartile range (IQR) | 385 |
Descriptive statistics
| Standard deviation | 501.1839 |
|---|---|
| Coefficient of variation (CV) | 0.3436704 |
| Kurtosis | 0.73242486 |
| Mean | 1458.3272 |
| Median Absolute Deviation (MAD) | 248 |
| Skewness | 1.1392183 |
| Sum | 9912250 |
| Variance | 251185.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1248 | 885 | 12.6% |
| 1197 | 715 | 10.2% |
| 998 | 393 | 5.6% |
| 796 | 375 | 5.4% |
| 2179 | 330 | 4.7% |
| 1498 | 318 | 4.5% |
| 1396 | 264 | 3.8% |
| 1199 | 233 | 3.3% |
| 2494 | 188 | 2.7% |
| 2523 | 171 | 2.4% |
| Other values (110) | 2925 | |
| (Missing) | 202 | 2.9% |
| Value | Count | Frequency (%) |
| 624 | 16 | 0.2% |
| 793 | 5 | 0.1% |
| 796 | 375 | |
| 799 | 66 | 0.9% |
| 814 | 99 | 1.4% |
| 909 | 2 | < 0.1% |
| 936 | 31 | 0.4% |
| 993 | 24 | 0.3% |
| 995 | 41 | 0.6% |
| 998 | 393 |
| Value | Count | Frequency (%) |
| 3604 | 5 | 0.1% |
| 3498 | 1 | < 0.1% |
| 3198 | 3 | < 0.1% |
| 2999 | 3 | < 0.1% |
| 2997 | 2 | < 0.1% |
| 2993 | 14 | |
| 2987 | 9 | 0.1% |
| 2982 | 28 | |
| 2967 | 9 | 0.1% |
| 2956 | 15 |
max_power
Real number (ℝ)
High correlation Missing
| Distinct | 313 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 197 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.500023 |
| Minimum | 0 |
|---|---|
| Maximum | 400 |
| Zeros | 6 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 47.299999 |
| Q1 | 68.050003 |
| median | 82 |
| Q3 | 102 |
| 95-th percentile | 171.5 |
| Maximum | 400 |
| Range | 400 |
| Interquartile range (IQR) | 33.949997 |
Descriptive statistics
| Standard deviation | 35.821621 |
|---|---|
| Coefficient of variation (CV) | 0.39149303 |
| Kurtosis | 3.891552 |
| Mean | 91.500023 |
| Median Absolute Deviation (MAD) | 14.959999 |
| Skewness | 1.6386213 |
| Sum | 622383.16 |
| Variance | 1283.1886 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 74 | 330 | 4.7% |
| 81.80000305 | 193 | 2.8% |
| 88.5 | 189 | 2.7% |
| 67 | 149 | 2.1% |
| 46.29999924 | 139 | 2.0% |
| 62.09999847 | 130 | 1.9% |
| 67.09999847 | 127 | 1.8% |
| 67.04000092 | 126 | 1.8% |
| 88.69999695 | 125 | 1.8% |
| 70 | 117 | 1.7% |
| Other values (303) | 5177 | |
| (Missing) | 197 | 2.8% |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.1% |
| 32.79999924 | 2 | < 0.1% |
| 34.20000076 | 19 | 0.3% |
| 35 | 16 | 0.2% |
| 35.5 | 2 | < 0.1% |
| 37 | 74 | |
| 37.47999954 | 8 | 0.1% |
| 37.5 | 6 | 0.1% |
| 38 | 1 | < 0.1% |
| 38.40000153 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 400 | 1 | < 0.1% |
| 282 | 1 | < 0.1% |
| 280 | 5 | |
| 272 | 1 | < 0.1% |
| 270.8999939 | 3 | |
| 265 | 1 | < 0.1% |
| 261.3999939 | 6 | |
| 258 | 2 | < 0.1% |
| 254.8000031 | 3 | |
| 254.7899933 | 1 | < 0.1% |
torque
Real number (ℝ)
High correlation Missing
| Distinct | 243 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 203 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 184.76681 |
| Minimum | 47.071918 |
|---|---|
| Maximum | 5001.3916 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 47.071918 |
|---|---|
| 5-th percentile | 69 |
| Q1 | 111.8 |
| median | 170 |
| Q3 | 209 |
| 95-th percentile | 360 |
| Maximum | 5001.3916 |
| Range | 4954.3198 |
| Interquartile range (IQR) | 97.199997 |
Descriptive statistics
| Standard deviation | 155.15225 |
|---|---|
| Coefficient of variation (CV) | 0.83971927 |
| Kurtosis | 316.4653 |
| Mean | 184.76681 |
| Median Absolute Deviation (MAD) | 56.25 |
| Skewness | 12.998838 |
| Sum | 1255675.3 |
| Variance | 24072.221 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 596 | 8.5% |
| 190 | 535 | 7.6% |
| 90 | 353 | 5.0% |
| 113 | 228 | 3.3% |
| 114 | 211 | 3.0% |
| 160 | 148 | 2.1% |
| 400 | 145 | 2.1% |
| 62 | 142 | 2.0% |
| 320 | 130 | 1.9% |
| 110 | 130 | 1.9% |
| Other values (233) | 4178 | |
| (Missing) | 203 | 2.9% |
| Value | Count | Frequency (%) |
| 47.07191849 | 1 | < 0.1% |
| 51 | 14 | 0.2% |
| 55.89790344 | 1 | < 0.1% |
| 57 | 2 | < 0.1% |
| 58.83990097 | 1 | < 0.1% |
| 59 | 92 | |
| 59.82056427 | 14 | 0.2% |
| 60 | 3 | < 0.1% |
| 62 | 142 | |
| 69 | 116 |
| Value | Count | Frequency (%) |
| 5001.391602 | 2 | < 0.1% |
| 2451.662598 | 2 | < 0.1% |
| 2059.396484 | 7 | |
| 1863.26355 | 1 | < 0.1% |
| 1421.964233 | 9 | |
| 1274.864502 | 3 | < 0.1% |
| 1127.764771 | 6 | |
| 1078.731445 | 1 | < 0.1% |
| 789 | 3 | < 0.1% |
| 640 | 1 | < 0.1% |
seats
Real number (ℝ)
High correlation Missing
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 202 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4190084 |
| Minimum | 2 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 27.5 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 14 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.96576655 |
|---|---|
| Coefficient of variation (CV) | 0.17821832 |
| Kurtosis | 4.0454431 |
| Mean | 5.4190084 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0111742 |
| Sum | 36833 |
| Variance | 0.93270504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 5393 | |
| 7 | 944 | 13.5% |
| 8 | 208 | 3.0% |
| 4 | 104 | 1.5% |
| 9 | 72 | 1.0% |
| 6 | 54 | 0.8% |
| 10 | 19 | 0.3% |
| 2 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| (Missing) | 202 | 2.9% |
| Value | Count | Frequency (%) |
| 2 | 2 | < 0.1% |
| 4 | 104 | 1.5% |
| 5 | 5393 | |
| 6 | 54 | 0.8% |
| 7 | 944 | 13.5% |
| 8 | 208 | 3.0% |
| 9 | 72 | 1.0% |
| 10 | 19 | 0.3% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 10 | 19 | 0.3% |
| 9 | 72 | 1.0% |
| 8 | 208 | 3.0% |
| 7 | 944 | 13.5% |
| 6 | 54 | 0.8% |
| 5 | 5393 | |
| 4 | 104 | 1.5% |
| 2 | 2 | < 0.1% |
Interactions
Correlations
| engine | fuel | km_driven | max_power | mileage | owner | seats | seller_type | selling_price | torque | transmission | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| engine | 1.000 | 0.450 | 0.238 | 0.736 | -0.462 | 0.082 | 0.515 | 0.229 | 0.512 | 0.844 | 0.489 | -0.006 |
| fuel | 0.450 | 1.000 | 0.035 | 0.168 | 0.309 | 0.031 | 0.213 | 0.108 | 0.110 | 0.027 | 0.050 | 0.122 |
| km_driven | 0.238 | 0.035 | 1.000 | -0.036 | -0.157 | 0.034 | 0.225 | 0.018 | -0.358 | 0.180 | 0.027 | -0.620 |
| max_power | 0.736 | 0.168 | -0.036 | 1.000 | -0.345 | 0.085 | 0.275 | 0.258 | 0.669 | 0.793 | 0.593 | 0.220 |
| mileage | -0.462 | 0.309 | -0.157 | -0.345 | 1.000 | 0.086 | -0.439 | 0.070 | -0.031 | -0.199 | 0.212 | 0.302 |
| owner | 0.082 | 0.031 | 0.034 | 0.085 | 0.086 | 1.000 | 0.034 | 0.169 | 0.364 | 0.032 | 0.169 | 0.269 |
| seats | 0.515 | 0.213 | 0.225 | 0.275 | -0.439 | 0.034 | 1.000 | 0.064 | 0.261 | 0.402 | 0.075 | -0.013 |
| seller_type | 0.229 | 0.108 | 0.018 | 0.258 | 0.070 | 0.169 | 0.064 | 1.000 | 0.282 | 0.000 | 0.373 | 0.185 |
| selling_price | 0.512 | 0.110 | -0.358 | 0.669 | -0.031 | 0.364 | 0.261 | 0.282 | 1.000 | 0.611 | 0.586 | 0.714 |
| torque | 0.844 | 0.027 | 0.180 | 0.793 | -0.199 | 0.032 | 0.402 | 0.000 | 0.611 | 1.000 | 0.154 | 0.126 |
| transmission | 0.489 | 0.050 | 0.027 | 0.593 | 0.212 | 0.169 | 0.075 | 0.373 | 0.586 | 0.154 | 1.000 | 0.269 |
| year | -0.006 | 0.122 | -0.620 | 0.220 | 0.302 | 0.269 | -0.013 | 0.185 | 0.714 | 0.126 | 0.269 | 1.000 |
Missing values
Sample
| name | year | selling_price | km_driven | fuel | seller_type | transmission | owner | mileage | engine | max_power | torque | seats | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Maruti Swift Dzire VDI | 2014 | 450000 | 145500 | Diesel | Individual | Manual | First Owner | 23.400000 | 1248.0 | 74.000000 | 190.000000 | 5.0 |
| 1 | Skoda Rapid 1.5 TDI Ambition | 2014 | 370000 | 120000 | Diesel | Individual | Manual | Second Owner | 21.139999 | 1498.0 | 103.519997 | 250.000000 | 5.0 |
| 2 | Hyundai i20 Sportz Diesel | 2010 | 225000 | 127000 | Diesel | Individual | Manual | First Owner | 23.000000 | 1396.0 | 90.000000 | 219.668961 | 5.0 |
| 3 | Maruti Swift VXI BSIII | 2007 | 130000 | 120000 | Petrol | Individual | Manual | First Owner | 16.100000 | 1298.0 | 88.199997 | 112.776474 | 5.0 |
| 4 | Hyundai Xcent 1.2 VTVT E Plus | 2017 | 440000 | 45000 | Petrol | Individual | Manual | First Owner | 20.139999 | 1197.0 | 81.860001 | 113.750000 | 5.0 |
| 5 | Maruti Wagon R LXI DUO BSIII | 2007 | 96000 | 175000 | LPG | Individual | Manual | First Owner | 17.299999 | 1061.0 | 57.500000 | 76.491867 | 5.0 |
| 6 | Maruti 800 DX BSII | 2001 | 45000 | 5000 | Petrol | Individual | Manual | Second Owner | 16.100000 | 796.0 | 37.000000 | 59.000000 | 4.0 |
| 7 | Toyota Etios VXD | 2011 | 350000 | 90000 | Diesel | Individual | Manual | First Owner | 23.590000 | 1364.0 | 67.099998 | 170.000000 | 5.0 |
| 8 | Ford Figo Diesel Celebration Edition | 2013 | 200000 | 169000 | Diesel | Individual | Manual | First Owner | 20.000000 | 1399.0 | 68.099998 | 160.000000 | 5.0 |
| 9 | Renault Duster 110PS Diesel RxL | 2014 | 500000 | 68000 | Diesel | Individual | Manual | Second Owner | 19.010000 | 1461.0 | 108.449997 | 248.000000 | 5.0 |
| name | year | selling_price | km_driven | fuel | seller_type | transmission | owner | mileage | engine | max_power | torque | seats | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6989 | Maruti Swift Dzire VDI | 2015 | 625000 | 50000 | Diesel | Individual | Manual | First Owner | 26.590000 | 1248.0 | 74.000000 | 190.000000 | 5.0 |
| 6990 | Hyundai i20 Magna | 2013 | 380000 | 25000 | Petrol | Individual | Manual | First Owner | 18.500000 | 1197.0 | 82.849998 | 113.699997 | 5.0 |
| 6991 | Maruti Wagon R LXI Optional | 2017 | 360000 | 80000 | Petrol | Individual | Manual | First Owner | 20.510000 | 998.0 | 67.040001 | 90.000000 | 5.0 |
| 6992 | Hyundai Santro Xing GLS | 2008 | 120000 | 191000 | Petrol | Individual | Manual | First Owner | 17.920000 | 1086.0 | 62.099998 | 96.099998 | 5.0 |
| 6993 | Maruti Wagon R VXI BS IV with ABS | 2013 | 260000 | 50000 | Petrol | Individual | Manual | Second Owner | 18.900000 | 998.0 | 67.099998 | 90.000000 | 5.0 |
| 6994 | Hyundai i20 Magna | 2013 | 320000 | 110000 | Petrol | Individual | Manual | First Owner | 18.500000 | 1197.0 | 82.849998 | 113.699997 | 5.0 |
| 6995 | Hyundai Verna CRDi SX | 2007 | 135000 | 119000 | Diesel | Individual | Manual | Fourth & Above Owner | 16.799999 | 1493.0 | 110.000000 | 235.359604 | 5.0 |
| 6996 | Maruti Swift Dzire ZDi | 2009 | 382000 | 120000 | Diesel | Individual | Manual | First Owner | 19.299999 | 1248.0 | 73.900002 | 190.000000 | 5.0 |
| 6997 | Tata Indigo CR4 | 2013 | 290000 | 25000 | Diesel | Individual | Manual | First Owner | 23.570000 | 1396.0 | 70.000000 | 140.000000 | 5.0 |
| 6998 | Tata Indigo CR4 | 2013 | 290000 | 25000 | Diesel | Individual | Manual | First Owner | 23.570000 | 1396.0 | 70.000000 | 140.000000 | 5.0 |
Duplicate rows
Most frequently occurring
| name | year | selling_price | km_driven | fuel | seller_type | transmission | owner | mileage | engine | max_power | torque | seats | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64 | Honda Amaze V CVT Petrol BSIV | 2019 | 779000 | 7032 | Petrol | Trustmark Dealer | Automatic | First Owner | 19.000000 | 1199.0 | 88.760002 | 110.000000 | 5.0 | 30 |
| 192 | Lexus ES 300h | 2019 | 5150000 | 20000 | Petrol | Dealer | Automatic | First Owner | 22.370001 | 2487.0 | 214.559998 | 202.000000 | 5.0 | 30 |
| 183 | Jaguar XF 2.0 Diesel Portfolio | 2017 | 3200000 | 45000 | Diesel | Dealer | Automatic | First Owner | 19.330000 | 1999.0 | 177.000000 | 430.000000 | 5.0 | 28 |
| 467 | Toyota Innova 2.5 VX (Diesel) 7 Seater | 2013 | 750000 | 79328 | Diesel | Trustmark Dealer | Manual | Second Owner | 12.990000 | 2494.0 | 100.599998 | 200.000000 | 7.0 | 28 |
| 13 | BMW X4 M Sport X xDrive20d | 2019 | 5400000 | 7500 | Diesel | Dealer | Automatic | First Owner | 16.780001 | 1995.0 | 190.000000 | 400.000000 | 5.0 | 27 |
| 255 | Maruti Baleno Alpha 1.3 | 2018 | 740000 | 38817 | Diesel | Dealer | Manual | First Owner | 27.389999 | 1248.0 | 74.000000 | 190.000000 | 5.0 | 27 |
| 306 | Maruti Swift AMT ZXI | 2018 | 600000 | 69779 | Petrol | Dealer | Automatic | First Owner | 22.000000 | 1197.0 | 81.800003 | 113.000000 | 5.0 | 27 |
| 363 | Maruti Wagon R LXI | 2013 | 225000 | 58343 | Petrol | Trustmark Dealer | Manual | First Owner | 21.790001 | 998.0 | 67.050003 | 90.000000 | 5.0 | 27 |
| 455 | Toyota Etios VX | 2017 | 625000 | 25538 | Petrol | Trustmark Dealer | Manual | First Owner | 16.780001 | 1496.0 | 88.730003 | 132.000000 | 5.0 | 27 |
| 114 | Hyundai Grand i10 1.2 CRDi Sportz | 2017 | 450000 | 56290 | Diesel | Dealer | Manual | First Owner | 24.000000 | 1186.0 | 73.970001 | 190.240005 | 5.0 | 26 |